EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

frmRename.zip

Excel user name

Get application user name or change it Originally from

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...